package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Scanner;

public class jdbc_Demo8 {

    public static void main(String[] args) {

        Scanner scanner=new Scanner(System.in);
        System.out.println("请输入用户名");
        String username=scanner.nextLine();
        System.out.println("请输入密码");
        String password=scanner.nextLine();
        System.out.println("请输入昵称");
        String nickname=scanner.nextLine();
        System.out.println("请输入年龄");
        int age=scanner.nextInt();

        try(Connection connection=DBUtil.getConnection()){
            String sql="INSERT INTO  user(username,password,nickname,age) "+
                       "VALUES(?,?,?,?)";
            PreparedStatement ps=connection.prepareStatement(sql);

            ps.setString(1,username);
            ps.setString(2,password);
            ps.setString(3,nickname);
            ps.setInt(4,age);
            int num=ps.executeUpdate();
            System.out.println(num>0?"登录成功":"登录失败s");
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}
